0# C:\Users\liutong\Documents\Tencent Files\707921012\FileRecv\辅导员压力数据.xls
import pandas as pd

df = pd.read_excel(r'C:\Users\liutong\Documents\Tencent Files\707921012\FileRecv\817.xls')
S1 = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
list1 = []
for i in range(len(S1)):
    list1.append(S1[i])
for i in ['A', 'B', 'C', 'D', 'E', 'F']:
    for n in range(len(S1)):
        list1.append(i+S1[n])
a = 0
for i in df.columns:
    for n in df.index:
        df[i][n] = list1[a] + str(df[i][n])
    a += 1
df.to_excel(r'C:\Users\liutong\Documents\辅导员.xls',index=False)
print('well done')
